Subscribers (Suscriptores)

How to view and manage newsletter subscribers in TuPerfil.net.

The subscribers section at /admin/suscriptores lists everyone who has signed up for the TuPerfil.net newsletter.

This page is only accessible to users with the admin role. Editors are redirected to the dashboard.

Subscriber overview

Two stat cards at the top give you an instant count:

Active

Subscribers who have not unsubscribed. They will receive the next newsletter campaign.

Inactive

Subscribers who clicked the unsubscribe link in an email, or who were manually deactivated by an admin.

Subscriber list

The list is split into two sections: Activos (green dot) and Inactivos (grey dot, strikethrough email). Each entry shows:

• Email address
• Name (if provided — it is optional in the sign-up form)
• Subscription date (for active) or unsubscribe date (for inactive)

Copying active emails

Click Copiar N emails activos to copy all active subscriber email addresses to your clipboard, one per line. This is useful if you want to send a one-off message using an external tool. The button shows ¡Copiado! for 2.5 seconds after a successful copy.

Manual deactivation

Click Dar de baja next to an active subscriber. You are asked to confirm. This sets active = false and records unsubscribed_at with the current timestamp. The subscriber moves to the Inactive section.

Reactivating a subscriber

Click Reactivar next to any inactive subscriber. This sets active = true and clears unsubscribed_at. The subscriber returns to the Active section and will receive future newsletters.

Subscribers can also unsubscribe themselves by clicking the unsubscribe link included automatically at the bottom of every newsletter email.

How readers subscribe

Readers subscribe through the newsletter widget on the public site. Submitting the form calls POST /api/newsletter/subscribe with their email and optional name. The API inserts a row into the subscribers table with active = true.

Subscriber fields reference

Field	Type	Notes
email	text	Required. Unique across all subscribers.
name	text or null	Optional name provided at sign-up.
active	boolean	true = will receive future emails.
created_at	timestamp	When the reader subscribed.
unsubscribed_at	timestamp or null	Set when the reader unsubscribes. Null if still active.